BibSonomy bookmarks for /user/fabian/wordpress%20comments

Front Page Comments on your WordPress Blog | TransformationPowerTools | for personal growth and transformation

fabian — 2010-10-18T13:05:24+02:00

http://www.transformationpowertools.com/wordpress/front-page-comments-wordpress-blog

How to Create a Comments Central Page Template in WordPress | Theme Lab

fabian — 2010-10-17T11:59:16+02:00

<h3>Recent Comments</h3> <ul id="cc-recent-comments"> <?php $max = 7; // number item to get global $wpdb; $sql = "SELECT c.*, p.post_title FROM $wpdb->comments c INNER JOIN $wpdb->posts p ON (c.comment_post_id=p.ID) WHERE comment_approved = '1' AND comment_type not in ('trackback','pingback') ORDER BY comment_date DESC LIMIT $max"; $results = $wpdb->get_results($sql); $template = '%g <a href="%au">%an</a> on <a href="%pu#comment-%cid">%pt</a>'; $echoed = 0; foreach ($results as $row) { $tags = array('%ct','%cd','%g','%pt','%pu','%au','%an','%cid'); $replacements = array($row->comment_title,$row->comment_date,get_avatar($row->comment_author_email,'32'),$row->post_title,get_permalink($row->comment_post_ID),$row->comment_author_url,$row->comment_author,$row->comment_ID); echo '<li>' . str_replace($tags,$replacements,$template) . '</li>'; $echoed = 1; } if ($echoed==0) echo '<li>No comment found.</li>'; ?> </ul>

10 Handy WordPress Comments Hacks - Smashing Magazine

fabian — 2010-10-17T11:58:48+02:00

http://www.smashingmagazine.com/2009/07/23/10-wordpress-comments-hacks/

Code: Adding Recent Comments To Your WordPress Theme

fabian — 2010-10-17T08:38:05+02:00

<h2>Recent Comments</h2> <?php global $wpdb; $sql = "SELECT DISTINCT ID, post_title, post_password, comment_ID, comment_post_ID, comment_author, comment_date_gmt, comment_approved, comment_type,comment_author_url, SUBSTRING(comment_content,1,30) AS com_excerpt FROM $wpdb->comments LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = $wpdb->posts.ID) WHERE comment_approved = '1' AND comment_type = '' AND post_password = '' ORDER BY comment_date_gmt DESC LIMIT 10"; $comments = $wpdb->get_results($sql); $output = $pre_HTML; $output .= "\n<ul>"; foreach ($comments as $comment) { $output .= "\n<li>".strip_tags($comment->comment_author) .":" . "<a href=\"" . get_permalink($comment->ID) . "#comment-" . $comment->comment_ID . "\" title=\"on " . $comment->post_title . "\">" . strip_tags($comment->com_excerpt) ."</a></li>"; } $output .= "\n</ul>"; $output .= $post_HTML; echo $output;?>